USE [MyTest]
GO

/****** Object:  Table [dbo].[TBL_SMS_MOBILES_20251221]    Script Date: 2025/10/23 15:24:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[TBL_SMS_MOBILES_20251221](
	[id] [bigint] NOT NULL,
	[mobile] [varchar](24) NULL,
	[cid] [bigint] NULL,
	[gateway] [int] NULL,
	[status] [smallint] NULL,
	[result] [varchar](12) NULL,
	[statusCode] [varchar](32) NULL,
	[sendTime] [datetime] NULL,
	[ucuid] [varchar](32) NULL,
	[price] [money] NULL,
	[msgcount] [tinyint] NULL,
	[displayNum] [varchar](32) NULL,
	[extNum] [varchar](32) NULL,
	[reSend] [tinyint] NULL,
	[clientMsgId] [varchar](32) NULL,
	[msgId] [varchar](48) NULL,
	[priority] [tinyint] NULL,
	[eprId] [int] NOT NULL,
	[areaId] [tinyint] NULL,
	[mobileType] [tinyint] NULL,
	[linkman] [varchar](32) NULL,
	[totalPrice] [money] NULL,
	[totalCost] [money] NULL,
	[deliverdTime] [datetime] NULL,
	[ctxType] [tinyint] NULL,
	[content] [nvarchar](2000) NULL,
	[addStatusTime] [datetime] NULL,
	[platform] [tinyint] NOT NULL,
	[area] [varchar](30) NULL,
	[tempId] [int] NULL,
	[contentType] [int] NULL,
	[exFlag] [int] NULL,
	[city] [varchar](50) NULL,
	[taskId] [int] NULL,
	[custTempId] [int] NULL,
	[onlyId] [bigint] NOT NULL,
	[mpResend] [tinyint] NOT NULL,
	[msgLen] [int] NOT NULL,
	[hfType] [tinyint] NOT NULL,
	[resendMbType] [tinyint] NOT NULL,
	[updateTime] [datetime2](3) NOT NULL,
	[originalId] [bigint] NULL,
	[originalSendTime] [datetime] NULL,
	[parentId] [bigint] NULL,
	[parentIdSendTime] [datetime] NULL,
	[reSendTimes] [int] NULL,
	[resendMode] [int] NULL,
 CONSTRAINT [PK_id_20251221] PRIMARY KEY NONCLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TBL_SMS_MOBILES_20251221] ADD  CONSTRAINT [DF_TBL_SMS_MOBILES_20251221_EPRID_4C6B5938]  DEFAULT ((0)) FOR [eprId]
GO

ALTER TABLE [dbo].[TBL_SMS_MOBILES_20251221] ADD  CONSTRAINT [DF_TBL_SMS_MOBILES_20251221_TOTALPRICE]  DEFAULT ((0)) FOR [totalPrice]
GO

ALTER TABLE [dbo].[TBL_SMS_MOBILES_20251221] ADD  CONSTRAINT [DF_TBL_SMS_MOBILES_20251221_TOTALCOST]  DEFAULT ((0)) FOR [totalCost]
GO

ALTER TABLE [dbo].[TBL_SMS_MOBILES_20251221] ADD  CONSTRAINT [DF_TBL_SMS_MOBILES_20251221_ctxty_5C387804]  DEFAULT (NULL) FOR [ctxType]
GO

ALTER TABLE [dbo].[TBL_SMS_MOBILES_20251221] ADD  CONSTRAINT [DF_TBL_SMS_MOBILES_20251221_conte__5D2C9C3D]  DEFAULT (NULL) FOR [content]
GO

ALTER TABLE [dbo].[TBL_SMS_MOBILES_20251221] ADD  CONSTRAINT [DF_TBL_SMS_MOBILES_20251221_platf__5E20C076]  DEFAULT ((0)) FOR [platform]
GO

ALTER TABLE [dbo].[TBL_SMS_MOBILES_20251221] ADD  CONSTRAINT [DF_TBL_SMS_MOBILES_20251221_contentType]  DEFAULT ((-2)) FOR [contentType]
GO

ALTER TABLE [dbo].[TBL_SMS_MOBILES_20251221] ADD  CONSTRAINT [DF_TBL_SMS_MOBILES_20251221_taskI__600908E8]  DEFAULT ((0)) FOR [taskId]
GO

ALTER TABLE [dbo].[TBL_SMS_MOBILES_20251221] ADD  CONSTRAINT [DF_TBL_SMS_MOBILES_20251221_custT__60FD2D21]  DEFAULT ((0)) FOR [custTempId]
GO

ALTER TABLE [dbo].[TBL_SMS_MOBILES_20251221] ADD  CONSTRAINT [DF__TBL_SMS_M__onlyI__20251221]  DEFAULT ((0)) FOR [onlyId]
GO

ALTER TABLE [dbo].[TBL_SMS_MOBILES_20251221] ADD  CONSTRAINT [DF__TBL_SMS_M__mpRes__20251221]  DEFAULT ((0)) FOR [mpResend]
GO

ALTER TABLE [dbo].[TBL_SMS_MOBILES_20251221] ADD  CONSTRAINT [DF__TBL_SMS_M__msgLe__20251221]  DEFAULT ((0)) FOR [msgLen]
GO

ALTER TABLE [dbo].[TBL_SMS_MOBILES_20251221] ADD  CONSTRAINT [DF__TBL_SMS_M__hfTyp__20251221]  DEFAULT ((0)) FOR [hfType]
GO

ALTER TABLE [dbo].[TBL_SMS_MOBILES_20251221] ADD  CONSTRAINT [DF__TBL_SMS_M__resen__20251221]  DEFAULT ((0)) FOR [resendMbType]
GO

ALTER TABLE [dbo].[TBL_SMS_MOBILES_20251221] ADD  CONSTRAINT [DF_TBL_SMS_MOBILES_20251221_updateTime]  DEFAULT (getdate()) FOR [updateTime]
GO


